<html>
<head>
<title>Add Employee</title>
<style type="text/css">
body {
	font-family:verdana,arial,sans-serif;
	font-size:10pt;
	margin:30px;
	background-color:#ffcc00;
	}
</style>

</head>
<body>
<h1>Add Employee Data</h1>
<br/>
<form name="addEmp" method="post" action="addemployee_action.php">

<p>Note: all field marked with * are required.</p>
<table>
<tr><td style='text-align:right'><label>*Employee ID: </td><td><input type="text" name="ID" /></label></td></tr>
<?php

        $username="bsc353_4";
        $password="sonbeans";
        $database="bsc353_4";

        mysql_connect("clipper.encs.concordia.ca",$username,$password) or die ("Unable to connect to database");

        @mysql_select_db($database) or die ("Unable to select database");

        $branchquery= "Select branchID from StoreBranch";
        $allbranch=mysql_query($branchquery) or die ("Query did not work");
        $numbranch= mysql_numrows($allbranch);


        mysql_close();

        echo"Select Store Branch ID";
        echo"<select name='branchid'>";
        echo"<option>Select One</option>";
        $i=0;
        while($i<$numbranch)
            {
            $value=mysql_result($allbranch,$i,"branchID");
            echo "<option>$value</option>";
            ++$i;
            }   
        echo"<option>All Of MBS</option>";
        echo"</select><br /><br />";
        ?>
<tr><td style='text-align:right'><label>*Name: </td><td><input type="text" name="name" /></label></td></tr>
<tr><td style='text-align:center'><input type="reset" name="modvalue" value="Clear"/></td>
<td style='text-align:center'><input type="submit" name="modvalue" value="Add"/></td></tr>
</table>

</form>
</body>
</html>